2014-12-02 - 10735 - Rel Notes - Program to Create Call Offs from Load File for Japan Portal Customers #SAPReleases2014

Release Notes - Draft

10735 : Program to create call offs from load file for Japan Portal Customers

Admin Info

---

Purpose	Create Call offs with reference to contract item using data from file as input
Release No	002
Submitted on	12/02/2014
Submitted by	Surya Basa
Environment	NECNED to NECNEQ
Sent To	Daniel Brennan
Object(s) created by	Deepak Yasam, Venkat Kondapally, Karthik Vinayagam
Object(s) tested by	Surya Basa, Siba Mohapatra
Transport Status	Created in NECNED100

Transport and Technical Objects

---

Sl.	Transport ID	Description	Object Name
1	NEDK928107	SD:10735:ZJ Delivery Block & Rejectn Reasn for Japan Calloff	V_TVLS V_TVAG /AFS/TVAG_V
2	NEDK928264	SD: 10735: New PO type JPC for Contract	V_T176 J_3AT176_V
3	NEDK928105	SD:10735 : Japan CallOff Creation Program	ZSD_JPN_ORD_CALL_OFF ZJPN_CALL_OFF ZJEDI
4	NEDK928028	SD:10735 : Japan Audit Reports For Order Upload	Z_SO_LOAD_AUDIT ZJCALL

Release Notes

---

For Infrastructure

NA

For Requestor

NA

Test Notes

---

System : NECNED500

PO #	Sold to	Ship to	Material #	Grid #	ATP Check	JAN #	Load file Qty	Ref. Contract #	Contract	Contract Allocation	Inventory	Expected Results	Actual Result	Pass/ Fail	Calloff #	Tested By	QA By
JP-00001	Call offs should be created if there's a valid open contract and w/o reference when not
	1016242	1016242	11089406	678	Z2	4549518154547	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with contract reference	Order line loaded with reference to contract	P	1947784	Siba Mohapatra	Surya Basa
				700	Z2	4549518154554	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with contract reference	Order line loaded with reference to contract
			11089411	678	Z3	4549518155148	1		No contract		Available	Order line should be loaded w/o contract reference	Order line loaded w/o reference to contract
				700	Z3	4549518155155	1		No contract		Available	Order line should be loaded w/o contract reference	Order line loaded w/o reference to contract
			11089407	678	Z2	4549518154646	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with contract reference	Order line loaded with reference to contract
				700	Z2	4549518154653	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with contract reference	Order line loaded with reference to contract
JP-00002	Multiple Contract References exist with Z2 and Z3 materials with free available inventory; orders should be created with reference if there's a match and w/o if not and consuming inventory from free available
	1016242	2065915	11089406	718	Z2	4549518154585	1	40006865	Single Contract	Not allocation	Not available	Order line should be loaded with contract reference	Order line should be loaded with contract reference	P	1947785	Siba Mohapatra	Surya Basa
			11089411	678	Z3	4549518155148	1		No contract		Available	Order line should be loaded w/o contract reference	Order line loaded w/o reference to contract
				700	Z3	4549518155155	1		No contract		Available	Order line should be loaded w/o contract reference	Order line loaded w/o reference to contract
			11089407	678	Z2	4549518154646	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with contract reference	Order line loaded with reference to contract
				700	Z2	4549518154653	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with contract reference	Order line loaded with reference to contract
JP-00003	Multiple Contract References exist and Z3 behaviour when there's no free available inventory and when both valid open contracts have the same validity period
	1016242	1016242	11089412	678	Z2	4549518155049	1	40006876, 40006877	Multiple Contract	Full allocation	Available	Order line should be loaded with first valid Contract & with delivery block and reject reason	Order line loaded with first valid Contract & with delivery block and reject reason	P	1947786	Siba Mohapatra	Surya Basa
				700	Z2	4549518155056	1	40006876, 40006877	Multiple Contract	Full allocation	Available	Order line should be loaded with 1st Contract # & reject reason	Order line loaded with 1st Contract # & reject reason
			11089411	718	Z3	4549518155186	1		No contract		Not available	Order line should be loaded with J0 rejection reason because of no inventory	Order line loaded with J0 rejection reason because of no inventory
JP-00004	Check behaviour when a line has RDD outside the validity period of open contracts
	1016242	1016242	11089406	678	Z2	4549518154547	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with contract reference.	Order line loaded with contract reference.	P	1947787	Siba Mohapatra	Surya Basa
				712	Z2	4549518154561	1	40006876, 40006877	Multiple Contract	Full allocation	Available	Order line should be loaded with reference to 1st valid contract & with delivery block and reject reason	Order line loaded with reference to 1st valid contract & with delivery block and reject reason
			11089411	718	Z3	4549518155186	1		No contract		Not available	Order line should be loaded with J0 rejection reason because of no inventory and w/o contract reference.	Order line loaded with J0 rejection reason because of no inventory and w/o contract reference.
				700	Z3	4549518155155	1		No contract		Available	Order line should be loaded without contract reference.	Order line loaded without contract reference.
			11089407	678	Z2	4549518154646	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with contract reference.	Order line loaded with contract reference.
				712	Z2	4549518154660	1	40006881	Exists but not in Req Del Dt	Full allocation	Available	Order line should be loaded without any contract reference	Order line loaded without any contract reference
JP-00001	Duplicate order or load file with PO# JP-00001 again (same combination of SP, SH and PO #)
	1016242	1016242	11089406	678	Z2	4549518154547	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with reference to contract and with delivery block	Order loaded with reference to contract and with delivery block at header.	P	1947788	Siba Mohapatra	Surya Basa
				700	Z2	4549518154554	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with reference to contract and with delivery block	Order loaded with reference to contract and with delivery block at header.
			11089411	678	Z3	4549518155148	1		No contract		Available	Order line should be loaded w/o reference to contract and with delivery block	Order loaded w/o reference to contract and with delivery block at header.
				700	Z3	4549518155155	1		No contract		Available	Order line should be loaded w/o reference to contract and with delivery block	Order loaded w/o reference to contract and with delivery block at header.
			11089407	678	Z2	4549518154646	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with reference to contract and with delivery block	Order loaded with reference to contract and with delivery block at header.
				700	Z2	4549518154653	1	40006861	Single Contract	Full allocation	Available	Order line should be loaded with reference to contract and with delivery block	Order loaded with reference to contract and with delivery block at header.
JP-00006	PO # blank in input file for a combination of SP, SH, PO #
	1016242	2065915	11089406	678	Z2	4549518154547	1	40006861	Single Contract	Full allocation	Available	Entire order should not be loaded and error message should be logged into Zerror table - ZJPN_CALL_OFF	Entire order not loaded and error message logged into Zerror table - ZJPN_CALL_OFF	P	NA	Siba Mohapatra	Surya Basa
				700	Z2	4549518154554	1	40006861	Single Contract	Full allocation	Available
			11089411	678	Z3	4549518155148	1		No contract		Available
				700	Z3	4549518155155	1		No contract		Available
JP-00007	Sold To blank in input file for a combination of SP, SH, PO #
	NA	1016242	11089406	678	Z2	4549518154547	1	40006861	Single Contract	Full allocation	Available	Entire order should not be loaded and error message should be logged into Zerror table - ZJPN_CALL_OFF	Entire order not loaded and error message logged into Zerror table - ZJPN_CALL_OFF	P	NA	Siba Mohapatra	Surya Basa
				700	Z2	4549518154554	1	40006861	Single Contract	Full allocation	Available
			11089411	678	Z3	4549518155148	1		No contract		Available
				700	Z3	4549518155155	1		No contract		Available
JP-00008	Ship To blank in input file for a combination of SP, SH, PO#
	1016242	NA	11089406	678	Z2	4549518154547	1	40006861	Single Contract	Full allocation	Available	Entire order should not be loaded and error message should be logged into Zerror table - ZJPN_CALL_OFF	Entire order not loaded and error message logged into Zerror table - ZJPN_CALL_OFF	P	NA	Siba Mohapatra	Surya Basa
				700	Z2	4549518154554	1	40006861	Single Contract	Full allocation	Available
			11089411	678	Z3	4549518155148	1		No contract		Available
				700	Z3	4549518155155	1		No contract		Available
JP-00009	RDD blank or invalid in input file for a combination of SP, SH, PO #
	1016242	1016242	11089406	678	Z2	4549518154547	1	40006861	Single Contract	Full allocation	Available	Entire order should not be loaded and error message should be logged into Zerror table - ZJPN_CALL_OFF	Entire order not loaded and error message logged into Zerror table - ZJPN_CALL_OFF	P	NA	Siba Mohapatra	Surya Basa
				700	Z2	4549518154554	1	40006861	Single Contract	Full allocation	Available
			11089411	678	Z3	4549518155148	1		No contract		Available
				700	Z3	4549518155155	1		No contract		Available
JP-000010	Cancel date blank or Invalid in input file for a combination of SP, SH, PO #
	1016242	2065915	11089406	678	Z2	4549518154547	1	40006861	Single Contract	Full allocation	Available	Entire order should not be loaded and error message should be logged into Zerror table - ZJPN_CALL_OFF	Entire order not loaded and error message logged into Zerror table - ZJPN_CALL_OFF	P	NA	Siba Mohapatra	Surya Basa
				700	Z2	4549518154554	1	40006861	Single Contract	Full allocation	Available
			11089411	678	Z3	4549518155148	1		No contract		Available
				700	Z3	4549518155155	1		No contract		Available
JP-000011	Quantity value ZERO or blank in input file for a combination of SP, SH, PO #
	1016242	1016242	11089406	678	Z2	4549518154547	0	40006861	Single Contract	Full allocation	Available	Entire order should not be loaded and error message should be logged into Zerror table - ZJPN_CALL_OFF	Entire order not loaded and error message logged into Zerror table - ZJPN_CALL_OFF	P	NA	Siba Mohapatra	Surya Basa
				700	Z2	4549518154554	0	40006861	Single Contract	Full allocation	Available
			11089411	678	Z3	4549518155148	0		No contract		Available
				700	Z3	4549518155155	0		No contract		Available
JP-000012	Invalid JAN ID/ Blank in file
	1016242	1016242	11089411	678	Z3	4549518155148	1		No contract		Available	Entire order should not be loaded and error message should be logged into Zerror table - ZJPN_CALL_OFF	Entire order not loaded and error message logged into Zerror table - ZJPN_CALL_OFF	P	NA	Siba Mohapatra	Surya Basa
				700	Z3	4549518155155	1		No contract		Available
	When Contract has 1 size with open qty 10 available and input the Load file for 2 calloffs for same size.
JP-000013A	1016242	1016242	11089409	678	Z2	4549518154844	1	40006866	Single Contract	Full allocation	Available	Call off should be loaded with contract reference	Call off loaded with contract reference and inventory was consumed from contract	P	1947793	Siba Mohapatra	Surya Basa
JP-000013B	1016242	1016242	11089409	678	Z2	4549518154844	1		No contract		Available	Sales order should be loaded w/o reference and inventory from free available should be consumed	Sales order was loaded w/o reference as the contract is fully consumed and free available inventory was consumed.	P	1947794
	When Contract has 2 sizes (738, 758) with 10 open qty available for each and two call offs for same size 738
JP-000013B1	1016242	1016242	11089409	738	Z2	4549518154905	1	40006879	Single Contract	Full allocation	Available	1st call off should be created with contract reference and open contract quantity should be consumed for size 738	1st call off created with contract reference and open quantity for size 738 was consumed completely	P	1947795	Siba Mohapatra	Surya Basa
JP-000013B2	1016242	1016242	11089409	738	Z2	4549518154905	1	40006879	Single Contract	Full allocation	Available	2nd call off should be created with contract reference consuming inventory from free available w/o delivery block	2nd call off created with contract reference w/o delivery block consuming inventory from free available.	P	1947796
JP-000014	Valid contract status open followed by call off quantity greater than open quantity for a combination of SP, SH, PO #
	1016242	1016242	11089409	700	Z2	4549518154851	1	40006867	Single Contract	Full Allocation	Available	Entire order should be loaded with reference to the contract with the total quantity	Entire Order was loaded	P	1947792	Siba Mohapatra	Surya Basa
JP-000015	Single valid open contract with PO Type JPC
	1016242	1016242	11089409	712	Z2	4549518154868	1	40006868 - JPC	Single Contract	Full Allocation	Available	Order line should be loaded w/o reference to contract.	Order line loaded w/o reference to contract.	P	1947789	Siba Mohapatra	Surya Basa
JP-000016	2 Contracts with PO type JPC & non JPC for the same JAN ID.
	1016242	1016242	11089409	714	Z2	4549518154875	1	40006869 - JPC, 40006870	Multiple Contract	Full Allocation	Available	Order line should be loaded with reference to Contract with PO type non-JPC.	Order line loaded with reference to contract - PO type Non-JPC	P	1947790	Siba Mohapatra	Surya Basa
JP-000017	4 Open Contracts for the same JAN ID. And 1st & 2nd contract with PO type JPC and rest with non-JPC PO type.
	1016242	1016242	11089409	718	Z2	4549518154882	1	40006871 - JPC, 40006872 - JPC, 40006873, 40006874	Multiple Contract	Full Allocation	Available	Order line should be loaded with reference to earliest Contract w/o PO type JPC and with ZJ block at header & rejection at item level.	Order line loaded with reference to earliest contract w/o PO type JPC and ZJ block at header & rejection at item level.	P	1947791	Siba Mohapatra	Surya Basa
JPT-11	When contract has two sizes with open quantity 10 each and w/o free inventory followed by two call offs
	1016242	1016242	11089412	712	Z2	4549518155063	15	40006883	Single	Full Allocation	Not Available	Order line should be loaded with referece to contract	Order line loaded with reference to contract for 10 quantity only and the remaining 5 was excluded as there is no free available inventory. There's no error message for left out quantity.		1947805	Siba Mohapatra	Surya Basa
JPT-12	1016242	1016242	11089412	712	Z2	4549518155063	15	40006883	Single	Full Allocation	Not Available	Order line should be loaded with referece to contract	Order line loaded with reference to contract for 15 quantity and the confirmation date was proposed by the system and the RDD from the file was not considered as there is no free available inventory	P	1947806	Siba Mohapatra	Surya Basa

Below is the load file with large data tested in NECNED500.
NED500_Japan_Contract-Calloff_LoadFile_Largedata.xlsx

• Load file contains 109 line items.
• As per the expected result, 18 Sales orders were created and 11 were not.
• Load test was done in background. Ref: Spool # 72691
• It took 147 seconds to complete the Job.

Note: Tcode - ZJEDI can be use for program - ZSD_JPN_ORD_CALL_OFF

System: NECNEQ100

NA

Reference Document (Specification or Production Support Break Fix)

---

Surya - 2014-11-11 - 10735 - Spec - Program to create call offs with ref to Contracts for Japan cust. portal orders